Hi,

We are using FIM 2010 in our QA environment

We have a SQL MA connecting to SQL 2005 and SQL 2005 is installed in a separate machine.

We have configured Export and DeltaImport run profiles to the SQL MA. Export will happen to a Table and DeltaImport from a view.

Export is successful but when running DeltaImport we are facing the issue and the error is as below.

Status: no-ma-start

Connection Status : failed connection

Error : column-list-reordering

Error Code : 0x80040e07

When i try to query the view as "select * from dbo.Testview" i am getting below error 

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Below is the query of the view

SELECT     A.column1, A.column2, A.column3, A.column4, A.column5, A.column6, A.column7, A.column8, A.column9, A.column10, A.column11, A.columnDate,B.EventType
FROM         dbo.TestTable AS A CROSS JOIN
                          (SELECT     'Delete' AS EventType) AS B
WHERE     (DATEDIFF(day, A.columnDate, GETDATE()) <= 1)

can anyone please let us know how we can tackle this issue. LogcreationDate is a column which will hold today's date and the datatype of this column in both table and view is Varchar(50)

Jyothi,

I think there is an issue at your SQL View side. Once you correct it, go to MA and refresh the Schema of the MA. this will help you.

Regards,

Manuj Khurana